package com.chen.springboot.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.chen.springboot.entity.Poster;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author chenchao
 * @date 2022/6/17 13:41
 */
@Mapper
public interface PosterMapper extends BaseMapper<Poster> {

    @Select("select *from poster where enable=1 order by sort desc ")
    List<Poster> selectIsEnablePoster();

    @Select("select *from poster where cover_url=1 ")
    List<Poster> selectCoverUrlPoster();

}
